E=(sorry only AOL E-Mail address, otherwise Snail Mail address)
Mail ShareWare fee
(20.00 / US Funds only) to:
Bob Bittner
PO Box 434
Arcata, Ca. 95521 USA
AOL : RBITT
(Previously registered users
can upgrade for no charge)
er 2.0 ?
Any comments or suggestions ?
Thank You !
NotesB
ymmR.%U
]\XTSQQ
|zywtwh
^]YWUR
~|{}}
~|wwspllijjl
~{{z|
}yvsomji
yz{|}
c_\[XTQPPNNM
jeb_[ZRQPNNLL
83.,&#
wrnlhc_WVUSQOOLMN
EB><83/*%""
Tcvxz}~
~zxvsmic`_[YVTRRX
FCB@?<962.,+'$#
"$ E\adghlnprux{|~
}|zyxurpkjheaa^\_`]x
CA?=;:9775320..,*,
8@9JQTWZ^adhkmprux|
*|{ywvusrrqonljhgefhhfnrn{
B?=<98765
4'323143345667>FILPSH
VZ^`aehlqsw|~
7{ywussqppoonnllkjkljjkkllqww{}
A>=;9765
5,66788:;<=?@ABIMPRVYZ\]adhloruxz|~
{xvusqqonnmn
ooppqrrsx{}
B>=;8765
4C5567799;<=?ACDEGILNRVYZ[]`bchjmorsvwy{}
{xvusqpon
m,nmnnoopqrstuvxy{}
C@=;8665
47556889;<=?ABEGHJNPRVXZ]`bdgimnpstvxy{|~
{ywtrqpon
opqrsuvwyz{}
EB>;865
4,566899<=>@BDEHJLORUXZ\`behjmqtuxyz|}~
wusqonn
m(nnopprssuwxy{}~
3B>99752332345779;<>?BDEGIKMPSVY\^`cfilosvyz|}
|yutronm
l#mnnopqsttvwxz|~
&1)*+,./13579;>?ACFGKLMORUWZ\_bdgimptwy{|~
h(jjkllmoopssN
uuxxy{|~
$).37:<?BFHKMOPRTVXZ\]_begjmquxz{|
W*Y\_`dgjmnpprtvwyz{|~~
068:>AEHKNSTVXY]__``abdfjlpsy|}
a\VUTS
Q,SVYgklnprsvwz{}}
568:>BFKOSVY\]`bdefgffghikq|
TNRPOR
MOTkklnoquwz{}
$5567;>DIOVY]`behjkmm
JKIJKJ^
lnptvy|
5"69>DKUZ^`cgjloqswxy|~
MLLKKJJ
lmpsw{~
77>EKSX[^dgjnpswy{|
MLLKKJJ
llprvy|
5?<9:;=DGT
\ bfruwvwyz{
{zyxyxxy{}~
MLLKK
IKipnm
prtz}}|
?'@GUT]hjgn{
~~||{|{|}||zyvtqnllkkmotz
DZkkip
~}zxtqnhfc_]\]^chow~
NNKKJJ
57@[gmv
}ytokfc^YTQNLMPT[dmy
tjl`n~]
SQSQKONJLIR
Uhjp}
~ztmhd_YRMHDA??BGNVabQ@
YTYSSRPONMKLLO}
}qKRv
zsnha\UOHD?:76689<#
tqm^^c^XTUUVi
|zvtsstuvb[YWWfW^SSRS
DB@A<;:=U_drx
~ytmg_YRLGB=84/**$#"!
}||ywwv
|yvrokkgeedbb`_]\\[\
ZYVSR`vs
{voib[UOHC=962.,*(&%$##"
}yvsqomlkii
hggfecca`
nkhruyxzyzy{}
}ztoib[UNGD?;840.,*('&&%$##!!
}zxuspnnllkj
hgfed
~~{zyxyy{}~
|ytod\UQLGD?;750.-*)('&%%$##"!
}zwvsponm
iihhf
~|zyyz{|}}~
{xqi^XSOJEB>:740.,*(('&%%$$%##
}|ywurponml
~|zyyz{|}}~
{xqi^XSOJEB>:740.,*(('&%%$$%##
}|ywurponml
ymmR.%U
]\XTSQQ
|zywtwh
^]YWUR
E(Welcome to the Small Time Bookkeeper 2.0
E Would You Like to see the Notes?
E.Would You Like to go to the Registration Form?
.E(Welcome to the Small Time Bookkeeper 2.0
E'Would You Like to Go to The Main Menu ?
This bookkeeping system is a direct result of searching for an accounting system that met my needs. I couldn
t find anything that I liked. Not an unusual complaint. It seems that no one really likes their B
accounting system. Even me sometimes. Anyway I needed something to get the job done, was suited to my kind of business, and could run as well on a Mac Plus as it could on a Mac IIci. Needless to say this system
}|{{}
~}}|}~
<- - - Previous
<- - - Next
Expenses
<- - - Previous
<- - - Next
undant if you have looked at the Invoices module which calculates total sales. Why have this information in two places?
Easy. What if you do not wish to use the Invoices module? What if you do some F
of your invoices on paper? What if you decide to use the Invoices module at two sales locations? Then you need a way to tie all this together.
your income from your receipts. This may seem a little red
;en you
ve got the time to do it. The scripts do the rest.
may not suit your needs at all. It was made for a small partnership that does both automotive and machine shop repairs.A working knowledge of File Maker Pro is required.
It is designed to be used by a buD
siness, working out of one checkbook, writing checks for all expenses with some support for cash or credit card expenses. Both the Demos and the Templates are password protected. To keep the file size small I h
ave only included a minimum number of records in the Demos.
There are seven modules for this system. Some are dependent on the others. Some will work as stand alone modules. You will need to customize cerF
tain information.
If you have a service oriented business, you can enter banking information on a monthly basis, and are willing to make some minor changes, then this system may work for you. The tax repo
counter for your checks. After that enter your checks, which get automatically numbered. That
s it. All you do is enter your income (from your monthly receipts or invoice module), deposits and service charges D
(from your monthly bank statement), and enter your checks when you
ve got the time to do it. The scripts do the rest.
There is a layout to enter your income from your receipts. This may seem a little red
<- - - Previous
<- - - Next
GENERAL NOTESA
<- - - Previous
<- - - Next
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
The Payroll module uses the Employees module as a lookup
file. The match is made by the Name field. All you need to do is enter
the employees name and the hours worked that week. Payroll is cal-
culated onB
a weekly basis. State tax is calculated by using a nested
If statement and only calculates tax up to $350 of wages.
This module will also calculate 941 reports, State EDD reports, and Workman
s Comp estimC
ates.
<- - - Return to Start
<- - - Previous
<- - - Next
E EMPLOYEES
The Employee module contains information about your employees.
This is where you enter all the data about your employees. Their names,
addresses, phone #. SS #, married or single, pay level, Workman
s ComB;p. etc.
The Payroll module uses this file as a lookup file.
The Expenses Template is
loaded
with twelve records that will be your income and bank information. (Twelve records = twelve months).
Enter the venders thB
at you wish to send 1099 Misc. forms to. This system assumes you won
t have more than twelve 1099
s to send.
Edit the value lists for check Descriptions, and Codes to suit your business. Reset the number
ClientsB
<- - - Previous
<- - - Next
CLIENTS
<- - - Previous
<- - - Next
INVOICES
The Invoice module will lookup a client
s address, phone number,
etc. from the Clients module. There are fields for parts and service sales
entries. The type of sales considered are Auto, Retail, Resale an
<- - - Previous
<- - - Next
PAYROLL
TransferB
<- - - Previous
<- - - Next
cripts written that do most of this for you.
At the end of the month run the A/R script Billing Query for the current month. Then go to Statements at the end of the script. At this point open the Transfer D
module and run the Transfer Prep script. You will be prompted to match the fields for import. Match the fields. After the records are imported you will be prompted to replace the counter field with serial numbe
<- - - Previous
<- - - Next
HOW TO CUSTOMIZE
Add your company name, etc. to the layouts Invoices and Statements.
Change the field definition of INTEREST from .015% per month if you want a different interest rate
<- - - Return to Start
<- - - Next
<- - - Previous
<- - - Next
bout it when they are charged interest. I mean let
s face it. The account received no payments and the
account did owe money for 30 days. Interest has accrued. Interest is set
at .015% per month. This is 18% peDzr annum.
This module also uses the Transfer module to carryover the ending
account balance. More about this later on.
avoids the dreaded Today function.
Also late accounts really can
t argue a
'bout it when they are charged interest.
were received during the month.
This isn
t quite standard but it avoids the dreaded Today function.
Also late accounts really can
t argue aC'bout it when they are charged interest.
The Accounts Receivable module depends on the Clients module to lookup the client
s address information. Data entry is not automatic, you must enter billing information manually. Interest is applied if theB
account had an opening balance greater than zero and no payments were received during the month. This isn
t quite standard but it avoids the dreaded Today function.
Also late accounts really can
t argue a
client
billing information, who to contact, essential information, and comments
about the client. This module is used by the A/R and the Invoices module
as a lookup file.
The Clients module is pretty straight forward. It has fields for the client
s billing information, who to contact, essential information, and comments about the client. This module is used by the A/R modulB
e and the Invoices module as a lookup file.
Lookups are dependent on matching the Name field. You may want to consider using account numbers for the matchup.
rt forms are specific to the state of California.
This system was designed to be a starting point. You will have
to make some changes. I do not support some accounting areas. For instance, sales of food arH
e not supported. On the tax forms it is assumed that you do not pay your taxes late, so there is no support for calculating penalties and interest. This could be added on later if needed.
ize small I h
PayrollB
ExpensesB
d USGS
for government sales. These categories determine how sales tax is applied, sorted and tallied.
There is also a checkbox for resale sales where tax is not to be applied.
Invoices also contains lCKayouts for generating an estimate, credit application, and FAX cover sheet.
nsferB
<- - - Previous
<- - - Next
TRANSFER
TransferB
<- - - Previous
<- - - Next
TRANSFER
rs. Replace with serial numbers incremented by one. Next you will be prompted to replace the date field like this :
Let
s say the date is 1/29/94 the end of January. Change the date on this record to 2/1/F
94 the first day of the next month February. Then the script will prompt you to replace all the dates in the found set. Replace them all.
Next you will go back to A/R and run the Transfer Import script. Yo
3rs. Replace with serial numbers incremented by one.
e month run the A/R script
The Transfer module solves a problem in carrying over receivable balances from one month to the next. Because A/R billings are formed from summarys it is necessary to export one month
s A/R to the TransferB
file, find all the duplicate records, and then import these records back into A/R with the dates adjusted and the current balance from one month entered as the beginning balance of the next month. There are s
u will be prompted to match the fields. Match them with the exception of the Current field in the Transfer file. Match this field with Opening Balance in A/R. Then import these records to A/R adding them to theH
file.
You now have a new set of records with dates for the first day of the month and opening balances that match the ending balances from the previous month. It
s easier than it sounds.
re are s
AmCLIENTS
Add fields for custom data if you want more client information. Secondary addresses or contacts, etc.
AQEMPLOYEES
Change the fields FTL, Pay Rate, and Comp Rate to your current levels.
Yesf3
EXPENSES
Edit the value list in the field DESCRIPTION to suit your business.
Edit the value list in the field CODE to suit your business.
Edit the calculation in the field CODE SORT ORDER to match your codes.
Change the value in the field SALES TAX to your current sales tax rate. It is now set at .0725%.
Do the same with the fields STATE TAX, COUNTY TAX, and LOCAL TAX.
Set the counter in the NUMBER field to where C*you want to start numbering your checks.
INVOICES
Add your company name, etc. to the layouts Fax, Estimate, and Invoice.
Change the field definition of LABOR RATE and SALES TAX to your current rates.
Reset the counter in INVOICE NO. field where you B
want it.
Yesf3
PAYROLL
Change the fields FED TAX, STATE TAX, FTL, EMPLOYEE SSI RATE, EMPLOYEE SDI RATE, EMPLOYEE MEDICARE RATE, EMPLOYER SSI RATE, EMPLOYER MC RATE, EMPLOYER TRAINING TAX, and EMPLOYER UI RATE to your current B
(.txt)